Dataset statistics
| Number of variables | 51 |
|---|---|
| Number of observations | 50000 |
| Missing cells | 746345 |
| Missing cells (%) | 29.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 19.5 MiB |
| Average record size in memory | 408.0 B |
Variable types
| CAT | 28 |
|---|---|
| NUM | 19 |
| BOOL | 4 |
Visibility has constant value "50000" | Constant |
CONNECTIONDETAIL has a high cardinality: 773 distinct values | High cardinality |
FILENAME_INGEST has a high cardinality: 5454 distinct values | High cardinality |
IP_DST has a high cardinality: 4521 distinct values | High cardinality |
IP_SRC has a high cardinality: 19797 distinct values | High cardinality |
LOCAL_TIMESTAMP has a high cardinality: 43546 distinct values | High cardinality |
MESSAGE has a high cardinality: 4260 distinct values | High cardinality |
TIME_RECEIPT has a high cardinality: 49932 distinct values | High cardinality |
TUNNELPARENTUUIDS has a high cardinality: 150 distinct values | High cardinality |
UUID_BRO has a high cardinality: 43576 distinct values | High cardinality |
COUNT_BYTES_IN_ONTHEWIRE is highly correlated with COUNT_BYTES_IN and 1 other fields | High correlation |
COUNT_BYTES_IN is highly correlated with COUNT_BYTES_IN_ONTHEWIRE and 2 other fields | High correlation |
COUNT_PACKETS_DST is highly correlated with COUNT_BYTES_IN and 3 other fields | High correlation |
COUNT_BYTES_OUT_ONTHEWIRE is highly correlated with COUNT_PACKETS_DST and 1 other fields | High correlation |
COUNT_PACKETS_SRC is highly correlated with COUNT_BYTES_IN and 2 other fields | High correlation |
LONGITUDE_SRC is highly correlated with LATITUDE_SRC | High correlation |
LATITUDE_SRC is highly correlated with LONGITUDE_SRC | High correlation |
NUMPACKETS_LOSS is highly correlated with NUMPACKETS_ACK and 1 other fields | High correlation |
NUMPACKETS_ACK is highly correlated with NUMPACKETS_LOSS and 1 other fields | High correlation |
NUMPACKETS_LOSS_PERCENT is highly correlated with NUMPACKETS_ACK and 1 other fields | High correlation |
APPLICATIONPROTOCOL has 49512 (99.0%) missing values | Missing |
ASN_DST has 7611 (15.2%) missing values | Missing |
ASN_SRC has 12658 (25.3%) missing values | Missing |
COCOM_DST has 7305 (14.6%) missing values | Missing |
COCOM_SRC has 11210 (22.4%) missing values | Missing |
CONNECTIONDETAIL has 6920 (13.8%) missing values | Missing |
CONNECTIONORIGIN_SRC has 6424 (12.8%) missing values | Missing |
CONNECTIONSTATE_BRO has 6424 (12.8%) missing values | Missing |
COUNTRY_DST has 7299 (14.6%) missing values | Missing |
COUNTRY_SRC has 11210 (22.4%) missing values | Missing |
COUNT_BYTES_IN has 9809 (19.6%) missing values | Missing |
COUNT_BYTES_IN_ONTHEWIRE has 6424 (12.8%) missing values | Missing |
COUNT_BYTES_MISSING has 6424 (12.8%) missing values | Missing |
COUNT_BYTES_OUT has 9809 (19.6%) missing values | Missing |
COUNT_BYTES_OUT_ONTHEWIRE has 6424 (12.8%) missing values | Missing |
COUNT_PACKETS_DST has 6424 (12.8%) missing values | Missing |
COUNT_PACKETS_SRC has 6424 (12.8%) missing values | Missing |
DURATION has 9809 (19.6%) missing values | Missing |
DURATION_LOG has 49995 (> 99.9%) missing values | Missing |
IPBRANCHCATEGORY_DST has 7112 (14.2%) missing values | Missing |
IPBRANCHCATEGORY_SRC has 11210 (22.4%) missing values | Missing |
IP_DST has 6424 (12.8%) missing values | Missing |
IP_SRC has 6424 (12.8%) missing values | Missing |
LATITUDE_DST has 7253 (14.5%) missing values | Missing |
LATITUDE_SRC has 11210 (22.4%) missing values | Missing |
LOCAL_TIMESTAMP has 6448 (12.9%) missing values | Missing |
LONGITUDE_DST has 7253 (14.5%) missing values | Missing |
LONGITUDE_SRC has 11210 (22.4%) missing values | Missing |
MESSAGE has 43581 (87.2%) missing values | Missing |
MSGSOURCE_BRO has 43581 (87.2%) missing values | Missing |
NUMPACKETS_ACK has 49995 (> 99.9%) missing values | Missing |
NUMPACKETS_LOSS has 49995 (> 99.9%) missing values | Missing |
NUMPACKETS_LOSS_PERCENT has 49995 (> 99.9%) missing values | Missing |
ORGANIZATION_OWNER_DST has 16526 (33.1%) missing values | Missing |
ORGANIZATION_OWNER_SRC has 11565 (23.1%) missing values | Missing |
PEERNAME has 43576 (87.2%) missing values | Missing |
PORT_DST has 6424 (12.8%) missing values | Missing |
PORT_SRC has 6424 (12.8%) missing values | Missing |
RESPONSEORIGIN_DST has 6424 (12.8%) missing values | Missing |
SEVERITY_MESSAGE has 43581 (87.2%) missing values | Missing |
TRANSPORTPROTOCOL has 6424 (12.8%) missing values | Missing |
TUNNELPARENTUUIDS has 49171 (98.3%) missing values | Missing |
UUID_BRO has 6424 (12.8%) missing values | Missing |
COUNT_BYTES_IN is highly skewed (γ1 = 147.4936546) | Skewed |
COUNT_BYTES_IN_ONTHEWIRE is highly skewed (γ1 = 132.3513756) | Skewed |
COUNT_BYTES_MISSING is highly skewed (γ1 = 74.33494996) | Skewed |
COUNT_BYTES_OUT is highly skewed (γ1 = 197.963122) | Skewed |
COUNT_BYTES_OUT_ONTHEWIRE is highly skewed (γ1 = 183.7178112) | Skewed |
COUNT_PACKETS_DST is highly skewed (γ1 = 167.6830686) | Skewed |
COUNT_PACKETS_SRC is highly skewed (γ1 = 187.0908029) | Skewed |
DURATION is highly skewed (γ1 = 147.1346037) | Skewed |
LOCAL_TIMESTAMP is uniformly distributed | Uniform |
TIME_RECEIPT is uniformly distributed | Uniform |
UUID_BRO is uniformly distributed | Uniform |
Id has unique values | Unique |
COUNT_BYTES_IN has 7119 (14.2%) zeros | Zeros |
COUNT_BYTES_IN_ONTHEWIRE has 7121 (14.2%) zeros | Zeros |
COUNT_BYTES_MISSING has 42079 (84.2%) zeros | Zeros |
COUNT_BYTES_OUT has 3820 (7.6%) zeros | Zeros |
COUNT_PACKETS_DST has 7121 (14.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-27 00:21:09.364203 |
|---|---|
| Analysis finished | 2020-09-27 00:22:30.476344 |
| Duration | 1 minute and 21.11 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 50000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| C02T641ElYCCkPQM0d | 1 |
|---|---|
| C0Ggaw1sl5r9ulrUr | 1 |
| C0A9jt1A03AqWyUXu6 | 1 |
| C0AQhri2n6PgTs0y8 | 1 |
| C0IcXh37lCyxgK8zT2 | 1 |
| Other values (49995) |
| Value | Count | Frequency (%) | |
| C02T641ElYCCkPQM0d | 1 | < 0.1% | |
| C0Ggaw1sl5r9ulrUr | 1 | < 0.1% | |
| C0A9jt1A03AqWyUXu6 | 1 | < 0.1% | |
| C0AQhri2n6PgTs0y8 | 1 | < 0.1% | |
| C0IcXh37lCyxgK8zT2 | 1 | < 0.1% | |
| C0HCR14SroAHVkT4X7 | 1 | < 0.1% | |
| C0LIl94o4xfyywAM36 | 1 | < 0.1% | |
| c3c73da459115b7e730df1abfbf4d20b | 1 | < 0.1% | |
| 19109bf416c7981f8faf2767141d66ab | 1 | < 0.1% | |
| C0Gq6l4iLBj4NYAGQ7 | 1 | < 0.1% | |
| Other values (49990) | 49990 | > 99.9% |
Frequencies of value counts
Unique
| Unique | 50000 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 32 |
|---|---|
| Median length | 18 |
| Mean length | 19.56816 |
| Min length | 15 |
Timestamp
Real number (ℝ≥0)
| Distinct | 49932 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.596695559e+12 |
|---|---|
| Minimum | 1.596326402e+12 |
| Maximum | 1.59693119e+12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 1.596326402e+12 |
|---|---|
| 5-th percentile | 1.596340139e+12 |
| Q1 | 1.596394845e+12 |
| median | 1.596803646e+12 |
| Q3 | 1.596871824e+12 |
| 95-th percentile | 1.596919144e+12 |
| Maximum | 1.59693119e+12 |
| Range | 604787859 |
| Interquartile range (IQR) | 476979580.8 |
Descriptive statistics
| Standard deviation | 226137106.1 |
|---|---|
| Coefficient of variation (CV) | 0.0001416281926 |
| Kurtosis | -1.360424371 |
| Mean | 1.596695559e+12 |
| Median Absolute Deviation (MAD) | 83517123 |
| Skewness | -0.6928314294 |
| Sum | 7.983477796e+16 |
| Variance | 5.113799077e+16 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1.596760674e+12 | 2 | < 0.1% | |
| 1.596839582e+12 | 2 | < 0.1% | |
| 1.596830582e+12 | 2 | < 0.1% | |
| 1.596853356e+12 | 2 | < 0.1% | |
| 1.596798516e+12 | 2 | < 0.1% | |
| 1.596384575e+12 | 2 | < 0.1% | |
| 1.596369643e+12 | 2 | < 0.1% | |
| 1.596771978e+12 | 2 | < 0.1% | |
| 1.596856856e+12 | 2 | < 0.1% | |
| 1.596800304e+12 | 2 | < 0.1% | |
| Other values (49922) | 49980 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1.596326402e+12 | 1 | < 0.1% | |
| 1.596326404e+12 | 1 | < 0.1% | |
| 1.596326411e+12 | 1 | < 0.1% | |
| 1.596326412e+12 | 1 | < 0.1% | |
| 1.59632642e+12 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1.59693119e+12 | 1 | < 0.1% | |
| 1.596931186e+12 | 1 | < 0.1% | |
| 1.596931169e+12 | 1 | < 0.1% | |
| 1.596931168e+12 | 1 | < 0.1% | |
| 1.596931164e+12 | 1 | < 0.1% |
Data Type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| bro-e-conn | |
|---|---|
| bro-e-communication | |
| bro-e-capture_loss | 5 |
| Value | Count | Frequency (%) | |
| bro-e-conn | 43576 | 87.2% | |
| bro-e-communication | 6419 | 12.8% | |
| bro-e-capture_loss | 5 | < 0.1% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 10 |
| Mean length | 11.15622 |
| Min length | 10 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| U&FOUO |
|---|
| Value | Count | Frequency (%) | |
| U&FOUO | 50000 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
| Distinct | 15 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 49512 |
| Missing (%) | 99.0% |
| Memory size | 390.6 KiB |
| ssl | |
|---|---|
| dns | |
| krb_tcp | |
| gssapi | |
| http | 8 |
| Other values (10) |
| Value | Count | Frequency (%) | |
| ssl | 163 | 0.3% | |
| dns | 160 | 0.3% | |
| krb_tcp | 66 | 0.1% | |
| gssapi | 56 | 0.1% | |
| http | 8 | < 0.1% | |
| ssh | 7 | < 0.1% | |
| gssapi,smb | 7 | < 0.1% | |
| ntlm,dce_rpc | 4 | < 0.1% | |
| smb,gssapi | 4 | < 0.1% | |
| dce_rpc,ntlm | 3 | < 0.1% | |
| Other values (5) | 10 | < 0.1% | |
| (Missing) | 49512 | 99.0% |
Frequencies of value counts
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.4% |
Histogram of lengths of the category
Length
| Max length | 23 |
|---|---|
| Median length | 3 |
| Mean length | 3.0132 |
| Min length | 3 |
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 7611 |
| Missing (%) | 15.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3791.493265 |
|---|---|
| Minimum | 71 |
| Maximum | 394353 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 71 |
|---|---|
| 5-th percentile | 531 |
| Q1 | 721 |
| median | 1569 |
| Q3 | 1585 |
| 95-th percentile | 16509 |
| Maximum | 394353 |
| Range | 394282 |
| Interquartile range (IQR) | 864 |
Descriptive statistics
| Standard deviation | 7334.624601 |
|---|---|
| Coefficient of variation (CV) | 1.934494957 |
| Kurtosis | 427.268434 |
| Mean | 3791.493265 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | 11.21922392 |
| Sum | 160717608 |
| Variance | 53796718.04 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1585 | 12764 | 25.5% | |
| 531 | 9421 | 18.8% | |
| 1569 | 3174 | 6.3% | |
| 16509 | 2917 | 5.8% | |
| 1537 | 2735 | 5.5% | |
| 8075 | 2340 | 4.7% | |
| 721 | 1461 | 2.9% | |
| 1562 | 771 | 1.5% | |
| 1563 | 717 | 1.4% | |
| 1556 | 700 | 1.4% | |
| Other values (167) | 5389 | 10.8% | |
| (Missing) | 7611 | 15.2% |
| Value | Count | Frequency (%) | |
| 71 | 1 | < 0.1% | |
| 109 | 32 | 0.1% | |
| 137 | 1 | < 0.1% | |
| 174 | 4 | < 0.1% | |
| 209 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 394353 | 1 | < 0.1% | |
| 393423 | 1 | < 0.1% | |
| 201081 | 3 | < 0.1% | |
| 135363 | 1 | < 0.1% | |
| 63473 | 1 | < 0.1% |
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 12658 |
| Missing (%) | 25.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1260.891115 |
|---|---|
| Minimum | 149 |
| Maximum | 27153 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 149 |
|---|---|
| 5-th percentile | 531 |
| Q1 | 531 |
| median | 1563 |
| Q3 | 1580 |
| 95-th percentile | 1585 |
| Maximum | 27153 |
| Range | 27004 |
| Interquartile range (IQR) | 1049 |
Descriptive statistics
| Standard deviation | 631.3074425 |
|---|---|
| Coefficient of variation (CV) | 0.5006835524 |
| Kurtosis | 666.8350051 |
| Mean | 1260.891115 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 16.17365691 |
| Sum | 47084196 |
| Variance | 398549.0869 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) | |
| 531 | 10776 | 21.6% | |
| 1585 | 5773 | 11.5% | |
| 1580 | 5703 | 11.4% | |
| 1563 | 3937 | 7.9% | |
| 1556 | 2141 | 4.3% | |
| 1565 | 1256 | 2.5% | |
| 1559 | 1242 | 2.5% | |
| 1566 | 1129 | 2.3% | |
| 1586 | 1029 | 2.1% | |
| 1569 | 985 | 2.0% | |
| Other values (26) | 3371 | 6.7% | |
| (Missing) | 12658 | 25.3% |
| Value | Count | Frequency (%) | |
| 149 | 3 | < 0.1% | |
| 367 | 2 | < 0.1% | |
| 386 | 8 | < 0.1% | |
| 493 | 86 | 0.2% | |
| 495 | 206 | 0.4% |
| Value | Count | Frequency (%) | |
| 27153 | 2 | < 0.1% | |
| 27142 | 1 | < 0.1% | |
| 27065 | 2 | < 0.1% | |
| 27064 | 3 | < 0.1% | |
| 26347 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7305 |
| Missing (%) | 14.6% |
| Memory size | 390.6 KiB |
| USEUCOM | |
|---|---|
| USNORTHCOM | |
| USINDOPACOM | 49 |
| USSOUTHCOM | 7 |
| USCENTCOM | 4 |
| Value | Count | Frequency (%) | |
| USEUCOM | 31912 | 63.8% | |
| USNORTHCOM | 10723 | 21.4% | |
| USINDOPACOM | 49 | 0.1% | |
| USSOUTHCOM | 7 | < 0.1% | |
| USCENTCOM | 4 | < 0.1% | |
| (Missing) | 7305 | 14.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 7.06348 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11210 |
| Missing (%) | 22.4% |
| Memory size | 390.6 KiB |
| USEUCOM | |
|---|---|
| USNORTHCOM | 891 |
| USINDOPACOM | 2 |
| Value | Count | Frequency (%) | |
| USEUCOM | 37897 | 75.8% | |
| USNORTHCOM | 891 | 1.8% | |
| USINDOPACOM | 2 | < 0.1% | |
| (Missing) | 11210 | 22.4% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 6.15682 |
| Min length | 3 |
| Distinct | 773 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 6920 |
| Missing (%) | 13.8% |
| Memory size | 390.6 KiB |
| Dd | |
|---|---|
| ShADadFf | |
| D | |
| Sr | |
| S | 1825 |
| Other values (768) |
| Value | Count | Frequency (%) | |
| Dd | 15676 | 31.4% | |
| ShADadFf | 3010 | 6.0% | |
| D | 2243 | 4.5% | |
| Sr | 1897 | 3.8% | |
| S | 1825 | 3.6% | |
| ShADadFr | 1673 | 3.3% | |
| ShADdaFf | 1623 | 3.2% | |
| ShAaDdFf | 1141 | 2.3% | |
| ShADdFf | 1047 | 2.1% | |
| ShADadtFf | 869 | 1.7% | |
| Other values (763) | 12076 | 24.2% | |
| (Missing) | 6920 | 13.8% |
Frequencies of value counts
Unique
| Unique | 383 ? |
|---|---|
| Unique (%) | 0.9% |
Histogram of lengths of the category
Length
| Max length | 31 |
|---|---|
| Median length | 3 |
| Mean length | 4.245 |
| Min length | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 38804 | 77.6% | |
| True | 4772 | 9.5% | |
| (Missing) | 6424 | 12.8% |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| SF | |
|---|---|
| S0 | |
| RSTR | |
| REJ | 1903 |
| RSTO | 1871 |
| Other values (8) |
| Value | Count | Frequency (%) | |
| SF | 27701 | 55.4% | |
| S0 | 4094 | 8.2% | |
| RSTR | 3725 | 7.4% | |
| REJ | 1903 | 3.8% | |
| RSTO | 1871 | 3.7% | |
| SH | 1806 | 3.6% | |
| OTH | 1570 | 3.1% | |
| RSTOS0 | 350 | 0.7% | |
| SHR | 291 | 0.6% | |
| S1 | 159 | 0.3% | |
| Other values (3) | 106 | 0.2% | |
| (Missing) | 6424 | 12.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 6 |
|---|---|
| Median length | 2 |
| Mean length | 2.45644 |
| Min length | 2 |
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7299 |
| Missing (%) | 14.6% |
| Memory size | 390.6 KiB |
| DE | |
|---|---|
| US | |
| IE | 672 |
| NL | 662 |
| GB | 276 |
| Other values (19) | 132 |
| Value | Count | Frequency (%) | |
| DE | 30263 | 60.5% | |
| US | 10696 | 21.4% | |
| IE | 672 | 1.3% | |
| NL | 662 | 1.3% | |
| GB | 276 | 0.6% | |
| CA | 33 | 0.1% | |
| KR | 11 | < 0.1% | |
| CN | 11 | < 0.1% | |
| AU | 10 | < 0.1% | |
| LU | 10 | < 0.1% | |
| Other values (14) | 57 | 0.1% | |
| (Missing) | 7299 | 14.6% |
Frequencies of value counts
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.14598 |
| Min length | 2 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11210 |
| Missing (%) | 22.4% |
| Memory size | 390.6 KiB |
| DE | |
|---|---|
| US | 891 |
| SM | 625 |
| JP | 2 |
| LU | 1 |
| Value | Count | Frequency (%) | |
| DE | 37271 | 74.5% | |
| US | 891 | 1.8% | |
| SM | 625 | 1.2% | |
| JP | 2 | < 0.1% | |
| LU | 1 | < 0.1% | |
| (Missing) | 11210 | 22.4% |
Frequencies of value counts
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.2242 |
| Min length | 2 |
| Distinct | 4862 |
|---|---|
| Distinct (%) | 12.1% |
| Missing | 9809 |
| Missing (%) | 19.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10767.78978 |
|---|---|
| Minimum | 0 |
| Maximum | 69236699 |
| Zeros | 7119 |
| Zeros (%) | 14.2% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 48 |
| median | 161 |
| Q3 | 1553 |
| 95-th percentile | 13806.5 |
| Maximum | 69236699 |
| Range | 69236699 |
| Interquartile range (IQR) | 1505 |
Descriptive statistics
| Standard deviation | 387608.0455 |
|---|---|
| Coefficient of variation (CV) | 35.99699228 |
| Kurtosis | 25521.838 |
| Mean | 10767.78978 |
| Median Absolute Deviation (MAD) | 161 |
| Skewness | 147.4936546 |
| Sum | 432768239 |
| Variance | 1.502399969e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 7119 | 14.2% | |
| 48 | 3220 | 6.4% | |
| 1552 | 1403 | 2.8% | |
| 1553 | 1166 | 2.3% | |
| 56 | 749 | 1.5% | |
| 173 | 721 | 1.4% | |
| 65 | 530 | 1.1% | |
| 3007 | 502 | 1.0% | |
| 116 | 413 | 0.8% | |
| 147 | 398 | 0.8% | |
| Other values (4852) | 23970 | 47.9% | |
| (Missing) | 9809 | 19.6% |
| Value | Count | Frequency (%) | |
| 0 | 7119 | 14.2% | |
| 1 | 3 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 7 | 90 | 0.2% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 69236699 | 1 | < 0.1% | |
| 16911966 | 1 | < 0.1% | |
| 15804767 | 1 | < 0.1% | |
| 11911928 | 1 | < 0.1% | |
| 10465445 | 1 | < 0.1% |
| Distinct | 5927 |
|---|---|
| Distinct (%) | 13.6% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11162.67631 |
|---|---|
| Minimum | 0 |
| Maximum | 72074863 |
| Zeros | 7121 |
| Zeros (%) | 14.2% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 76 |
| median | 177 |
| Q3 | 1924 |
| 95-th percentile | 14956 |
| Maximum | 72074863 |
| Range | 72074863 |
| Interquartile range (IQR) | 1848 |
Descriptive statistics
| Standard deviation | 416161.3393 |
|---|---|
| Coefficient of variation (CV) | 37.281502 |
| Kurtosis | 21326.62828 |
| Mean | 11162.67631 |
| Median Absolute Deviation (MAD) | 177 |
| Skewness | 132.3513756 |
| Sum | 486424783 |
| Variance | 1.731902603e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 7121 | 14.2% | |
| 76 | 3224 | 6.4% | |
| 40 | 2246 | 4.5% | |
| 1924 | 1055 | 2.1% | |
| 84 | 760 | 1.5% | |
| 1925 | 711 | 1.4% | |
| 93 | 534 | 1.1% | |
| 144 | 436 | 0.9% | |
| 170 | 380 | 0.8% | |
| 118 | 347 | 0.7% | |
| Other values (5917) | 26762 | 53.5% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 7121 | 14.2% | |
| 29 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 40 | 2246 | 4.5% | |
| 44 | 26 | 0.1% |
| Value | Count | Frequency (%) | |
| 72074863 | 1 | < 0.1% | |
| 27757656 | 1 | < 0.1% | |
| 18501992 | 1 | < 0.1% | |
| 17054843 | 1 | < 0.1% | |
| 16354114 | 1 | < 0.1% |
| Distinct | 412 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 591.0926427 |
|---|---|
| Minimum | 0 |
| Maximum | 2162121 |
| Zeros | 42079 |
| Zeros (%) | 84.2% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2162121 |
| Range | 2162121 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 25497.9814 |
|---|---|
| Coefficient of variation (CV) | 43.13703057 |
| Kurtosis | 5990.284187 |
| Mean | 591.0926427 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 74.33494996 |
| Sum | 25757453 |
| Variance | 650147055.6 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 42079 | 84.2% | |
| 1460 | 505 | 1.0% | |
| 5840 | 95 | 0.2% | |
| 4380 | 87 | 0.2% | |
| 2920 | 64 | 0.1% | |
| 7228 | 58 | 0.1% | |
| 7300 | 28 | 0.1% | |
| 126 | 23 | < 0.1% | |
| 1 | 19 | < 0.1% | |
| 8688 | 17 | < 0.1% | |
| Other values (402) | 601 | 1.2% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 42079 | 84.2% | |
| 1 | 19 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 6 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2162121 | 1 | < 0.1% | |
| 2150273 | 1 | < 0.1% | |
| 2149569 | 1 | < 0.1% | |
| 2149120 | 1 | < 0.1% | |
| 2147680 | 1 | < 0.1% |
| Distinct | 4076 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 9809 |
| Missing (%) | 19.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21767.20865 |
|---|---|
| Minimum | 0 |
| Maximum | 693224606 |
| Zeros | 3820 |
| Zeros (%) | 7.6% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 48 |
| median | 180 |
| Q3 | 1177 |
| 95-th percentile | 4393 |
| Maximum | 693224606 |
| Range | 693224606 |
| Interquartile range (IQR) | 1129 |
Descriptive statistics
| Standard deviation | 3473318.227 |
|---|---|
| Coefficient of variation (CV) | 159.5665426 |
| Kurtosis | 39482.70332 |
| Mean | 21767.20865 |
| Median Absolute Deviation (MAD) | 180 |
| Skewness | 197.963122 |
| Sum | 874845883 |
| Variance | 1.20639395e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 3820 | 7.6% | |
| 48 | 3422 | 6.8% | |
| 674 | 2610 | 5.2% | |
| 49 | 1284 | 2.6% | |
| 45 | 922 | 1.8% | |
| 38 | 884 | 1.8% | |
| 734 | 882 | 1.8% | |
| 50 | 675 | 1.4% | |
| 180 | 618 | 1.2% | |
| 44 | 550 | 1.1% | |
| Other values (4066) | 24524 | 49.0% | |
| (Missing) | 9809 | 19.6% |
| Value | Count | Frequency (%) | |
| 0 | 3820 | 7.6% | |
| 1 | 49 | 0.1% | |
| 8 | 1 | < 0.1% | |
| 12 | 7 | < 0.1% | |
| 13 | 94 | 0.2% |
| Value | Count | Frequency (%) | |
| 693224606 | 1 | < 0.1% | |
| 63173166 | 1 | < 0.1% | |
| 15412438 | 1 | < 0.1% | |
| 5803443 | 1 | < 0.1% | |
| 4835122 | 1 | < 0.1% |
| Distinct | 5295 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4913.511061 |
|---|---|
| Minimum | 0 |
| Maximum | 66011526 |
| Zeros | 259 |
| Zeros (%) | 0.5% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 76 |
| median | 231 |
| Q3 | 1488 |
| 95-th percentile | 5605.5 |
| Maximum | 66011526 |
| Range | 66011526 |
| Interquartile range (IQR) | 1412 |
Descriptive statistics
| Standard deviation | 332189.1295 |
|---|---|
| Coefficient of variation (CV) | 67.60728232 |
| Kurtosis | 35933.5896 |
| Mean | 4913.511061 |
| Median Absolute Deviation (MAD) | 179 |
| Skewness | 183.7178112 |
| Sum | 214111158 |
| Variance | 1.103496177e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 76 | 3776 | 7.6% | |
| 1046 | 2356 | 4.7% | |
| 52 | 1697 | 3.4% | |
| 77 | 1308 | 2.6% | |
| 73 | 924 | 1.8% | |
| 66 | 897 | 1.8% | |
| 78 | 776 | 1.6% | |
| 40 | 736 | 1.5% | |
| 72 | 554 | 1.1% | |
| 104 | 496 | 1.0% | |
| Other values (5285) | 30056 | 60.1% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 259 | 0.5% | |
| 28 | 1 | < 0.1% | |
| 29 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 40 | 736 | 1.5% |
| Value | Count | Frequency (%) | |
| 66011526 | 1 | < 0.1% | |
| 15643690 | 1 | < 0.1% | |
| 12307128 | 1 | < 0.1% | |
| 5199511 | 1 | < 0.1% | |
| 2191159 | 1 | < 0.1% |
| Distinct | 371 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.81402607 |
|---|---|
| Minimum | 0 |
| Maximum | 101363 |
| Zeros | 7121 |
| Zeros (%) | 14.2% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 9 |
| 95-th percentile | 23 |
| Maximum | 101363 |
| Range | 101363 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 526.124962 |
|---|---|
| Coefficient of variation (CV) | 33.26951402 |
| Kurtosis | 31714.46968 |
| Mean | 15.81402607 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 167.6830686 |
| Sum | 689112 |
| Variance | 276807.4757 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 17050 | 34.1% | |
| 0 | 7121 | 14.2% | |
| 9 | 3095 | 6.2% | |
| 10 | 1730 | 3.5% | |
| 4 | 1391 | 2.8% | |
| 2 | 1259 | 2.5% | |
| 6 | 1220 | 2.4% | |
| 7 | 1132 | 2.3% | |
| 5 | 1066 | 2.1% | |
| 8 | 978 | 2.0% | |
| Other values (361) | 7534 | 15.1% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 7121 | 14.2% | |
| 1 | 17050 | 34.1% | |
| 2 | 1259 | 2.5% | |
| 3 | 573 | 1.1% | |
| 4 | 1391 | 2.8% |
| Value | Count | Frequency (%) | |
| 101363 | 1 | < 0.1% | |
| 20746 | 1 | < 0.1% | |
| 18548 | 1 | < 0.1% | |
| 13885 | 1 | < 0.1% | |
| 12352 | 1 | < 0.1% |
| Distinct | 355 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.48467046 |
|---|---|
| Minimum | 0 |
| Maximum | 101370 |
| Zeros | 259 |
| Zeros (%) | 0.5% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 9 |
| 95-th percentile | 24 |
| Maximum | 101370 |
| Range | 101370 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 504.9023609 |
|---|---|
| Coefficient of variation (CV) | 34.85770438 |
| Kurtosis | 37308.79434 |
| Mean | 14.48467046 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 187.0908029 |
| Sum | 631184 |
| Variance | 254926.3941 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 19827 | 39.7% | |
| 9 | 3644 | 7.3% | |
| 10 | 1962 | 3.9% | |
| 2 | 1918 | 3.8% | |
| 8 | 1771 | 3.5% | |
| 7 | 1579 | 3.2% | |
| 6 | 1475 | 2.9% | |
| 11 | 1411 | 2.8% | |
| 4 | 1384 | 2.8% | |
| 3 | 1257 | 2.5% | |
| Other values (345) | 7348 | 14.7% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 259 | 0.5% | |
| 1 | 19827 | 39.7% | |
| 2 | 1918 | 3.8% | |
| 3 | 1257 | 2.5% | |
| 4 | 1384 | 2.8% |
| Value | Count | Frequency (%) | |
| 101370 | 1 | < 0.1% | |
| 17496 | 1 | < 0.1% | |
| 9825 | 1 | < 0.1% | |
| 8259 | 1 | < 0.1% | |
| 6945 | 1 | < 0.1% |
| Distinct | 31048 |
|---|---|
| Distinct (%) | 77.3% |
| Missing | 9809 |
| Missing (%) | 19.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.23925981 |
|---|---|
| Minimum | 1e-06 |
| Maximum | 300819.7988 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 1e-06 |
|---|---|
| 5-th percentile | 0.000229 |
| Q1 | 0.004461 |
| median | 0.077013 |
| Q3 | 0.753939 |
| 95-th percentile | 60.109311 |
| Maximum | 300819.7988 |
| Range | 300819.7988 |
| Interquartile range (IQR) | 0.749478 |
Descriptive statistics
| Standard deviation | 1733.392464 |
|---|---|
| Coefficient of variation (CV) | 55.48762919 |
| Kurtosis | 23951.28047 |
| Mean | 31.23925981 |
| Median Absolute Deviation (MAD) | 0.076232 |
| Skewness | 147.1346037 |
| Sum | 1255537.091 |
| Variance | 3004649.435 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.000206 | 39 | 0.1% | |
| 0.000189 | 35 | 0.1% | |
| 0.000175 | 35 | 0.1% | |
| 0.000204 | 35 | 0.1% | |
| 0.000193 | 34 | 0.1% | |
| 0.000207 | 33 | 0.1% | |
| 0.000213 | 33 | 0.1% | |
| 0.000234 | 33 | 0.1% | |
| 0.000191 | 32 | 0.1% | |
| 0.000192 | 31 | 0.1% | |
| Other values (31038) | 39851 | 79.7% | |
| (Missing) | 9809 | 19.6% |
| Value | Count | Frequency (%) | |
| 1e-06 | 1 | < 0.1% | |
| 2e-06 | 1 | < 0.1% | |
| 3e-06 | 12 | < 0.1% | |
| 4e-06 | 15 | < 0.1% | |
| 5e-06 | 23 | < 0.1% |
| Value | Count | Frequency (%) | |
| 300819.7988 | 1 | < 0.1% | |
| 149135.7421 | 1 | < 0.1% | |
| 43158.69052 | 1 | < 0.1% | |
| 41980.41467 | 1 | < 0.1% | |
| 41096.85332 | 1 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 49995 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 900.0000856 |
|---|---|
| Minimum | 900.000001 |
| Maximum | 900.000145 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 900.000001 |
|---|---|
| 5-th percentile | 900.0000164 |
| Q1 | 900.000078 |
| median | 900.000093 |
| Q3 | 900.000111 |
| 95-th percentile | 900.0001382 |
| Maximum | 900.000145 |
| Range | 0.000144 |
| Interquartile range (IQR) | 3.300000003e-05 |
Descriptive statistics
| Standard deviation | 5.348644687e-05 |
|---|---|
| Coefficient of variation (CV) | 5.942937976e-08 |
| Kurtosis | 0 |
| Mean | 900.0000856 |
| Median Absolute Deviation (MAD) | 1.799999995e-05 |
| Skewness | -1.033559485 |
| Sum | 4500.000428 |
| Variance | 2.860799999e-09 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 900.000001 | 1 | < 0.1% | |
| 900.000111 | 1 | < 0.1% | |
| 900.000093 | 1 | < 0.1% | |
| 900.000078 | 1 | < 0.1% | |
| 900.000145 | 1 | < 0.1% | |
| (Missing) | 49995 | > 99.9% |
| Value | Count | Frequency (%) | |
| 900.000001 | 1 | < 0.1% | |
| 900.000078 | 1 | < 0.1% | |
| 900.000093 | 1 | < 0.1% | |
| 900.000111 | 1 | < 0.1% | |
| 900.000145 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 900.000145 | 1 | < 0.1% | |
| 900.000111 | 1 | < 0.1% | |
| 900.000093 | 1 | < 0.1% | |
| 900.000078 | 1 | < 0.1% | |
| 900.000001 | 1 | < 0.1% |
| Distinct | 5454 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0015.bro-conn.369ed.gz | 98 |
|---|---|
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0945.bro-conn.801f6.gz | 85 |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-07-2230.bro-conn.a10ae.gz | 84 |
| bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-02-0015.bro-conn.3f1d1.gz | 83 |
| bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-07-2230.bro-conn.c342f.gz | 82 |
| Other values (5449) |
| Value | Count | Frequency (%) | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0015.bro-conn.369ed.gz | 98 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0945.bro-conn.801f6.gz | 85 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-07-2230.bro-conn.a10ae.gz | 84 | 0.2% | |
| bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-02-0015.bro-conn.3f1d1.gz | 83 | 0.2% | |
| bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-07-2230.bro-conn.c342f.gz | 82 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-07-0745.bro-conn.608c7.gz | 81 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-02-0015.bro-conn.3087c.gz | 81 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0930.bro-conn.ec507.gz | 77 | 0.2% | |
| bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-0615.bro-conn.c406a.gz | 76 | 0.2% | |
| bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-1700.bro-conn.56cd3.gz | 76 | 0.2% | |
| Other values (5444) | 49177 | 98.4% |
Frequencies of value counts
Unique
| Unique | 1579 ? |
|---|---|
| Unique (%) | 3.2% |
Histogram of lengths of the category
Length
| Max length | 84 |
|---|---|
| Median length | 73 |
| Mean length | 74.06198 |
| Min length | 63 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7112 |
| Missing (%) | 14.2% |
| Memory size | 390.6 KiB |
| Army | |
|---|---|
| Non-Army |
| Value | Count | Frequency (%) | |
| Army | 33474 | 66.9% | |
| Non-Army | 9414 | 18.8% | |
| (Missing) | 7112 | 14.2% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.61088 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11210 |
| Missing (%) | 22.4% |
| Memory size | 390.6 KiB |
| Army | |
|---|---|
| Non-Army | 355 |
| Value | Count | Frequency (%) | |
| Army | 38435 | 76.9% | |
| Non-Army | 355 | 0.7% | |
| (Missing) | 11210 | 22.4% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 3.8042 |
| Min length | 3 |
| Distinct | 4521 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| 52.11.247.82 | 2611 |
|---|---|
| 155.155.72.10 | 2530 |
| 139.139.3.146 | 2510 |
| 155.155.72.9 | 1895 |
| 136.215.193.9 | 1778 |
| Other values (4516) |
| Value | Count | Frequency (%) | |
| 52.11.247.82 | 2611 | 5.2% | |
| 155.155.72.10 | 2530 | 5.1% | |
| 139.139.3.146 | 2510 | 5.0% | |
| 155.155.72.9 | 1895 | 3.8% | |
| 136.215.193.9 | 1778 | 3.6% | |
| 136.215.178.120 | 1687 | 3.4% | |
| 136.215.78.120 | 1653 | 3.3% | |
| 134.232.201.9 | 1478 | 3.0% | |
| 164.169.0.6 | 1369 | 2.7% | |
| 164.169.0.22 | 1366 | 2.7% | |
| Other values (4511) | 24699 | 49.4% | |
| (Missing) | 6424 | 12.8% |
Frequencies of value counts
Unique
| Unique | 3341 ? |
|---|---|
| Unique (%) | 7.7% |
Histogram of lengths of the category
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 11.77816 |
| Min length | 3 |
| Distinct | 19797 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| 155.155.237.11 | 1401 |
|---|---|
| 155.155.72.10 | 495 |
| 155.155.72.9 | 448 |
| 155.24.116.43 | 415 |
| 136.218.18.66 | 380 |
| Other values (19792) |
| Value | Count | Frequency (%) | |
| 155.155.237.11 | 1401 | 2.8% | |
| 155.155.72.10 | 495 | 1.0% | |
| 155.155.72.9 | 448 | 0.9% | |
| 155.24.116.43 | 415 | 0.8% | |
| 136.218.18.66 | 380 | 0.8% | |
| 136.215.64.45 | 362 | 0.7% | |
| 147.35.17.34 | 335 | 0.7% | |
| 136.215.64.43 | 307 | 0.6% | |
| 136.215.177.137 | 279 | 0.6% | |
| 147.36.253.82 | 268 | 0.5% | |
| Other values (19787) | 38886 | 77.8% | |
| (Missing) | 6424 | 12.8% |
Frequencies of value counts
Unique
| Unique | 12849 ? |
|---|---|
| Unique (%) | 29.5% |
Histogram of lengths of the category
Length
| Max length | 25 |
|---|---|
| Median length | 13 |
| Mean length | 11.94806 |
| Min length | 3 |
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7253 |
| Missing (%) | 14.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.21507066 |
|---|---|
| Minimum | -33.5318 |
| Maximum | 59.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | -33.5318 |
|---|---|
| 5-th percentile | 33.41516 |
| Q1 | 45.8491 |
| median | 50.084075 |
| Q3 | 50.084075 |
| 95-th percentile | 50.084075 |
| Maximum | 59.95 |
| Range | 93.4818 |
| Interquartile range (IQR) | 4.234975 |
Descriptive statistics
| Standard deviation | 5.923323035 |
|---|---|
| Coefficient of variation (CV) | 0.1254540754 |
| Kurtosis | 14.59508794 |
| Mean | 47.21507066 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.463274226 |
| Sum | 2018302.625 |
| Variance | 35.08575578 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 50.084075 | 30230 | 60.5% | |
| 37.751 | 3140 | 6.3% | |
| 33.41516 | 2739 | 5.5% | |
| 45.8491 | 2626 | 5.3% | |
| 53.3338 | 660 | 1.3% | |
| 36.6534 | 526 | 1.1% | |
| 52.3759 | 463 | 0.9% | |
| 38.7095 | 251 | 0.5% | |
| 31.567824 | 231 | 0.5% | |
| 37.3388 | 200 | 0.4% | |
| Other values (117) | 1681 | 3.4% | |
| (Missing) | 7253 | 14.5% |
| Value | Count | Frequency (%) | |
| -33.5318 | 1 | < 0.1% | |
| -33.494 | 9 | < 0.1% | |
| -33 | 7 | < 0.1% | |
| -6.175 | 4 | < 0.1% | |
| 21.34585 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 59.95 | 1 | < 0.1% | |
| 59.9452 | 1 | < 0.1% | |
| 59.3247 | 6 | < 0.1% | |
| 54.5673 | 5 | < 0.1% | |
| 54.5667 | 1 | < 0.1% |
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11210 |
| Missing (%) | 22.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.70427453 |
|---|---|
| Minimum | 29.460896 |
| Maximum | 50.084075 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 29.460896 |
|---|---|
| 5-th percentile | 50.084075 |
| Q1 | 50.084075 |
| median | 50.084075 |
| Q3 | 50.084075 |
| 95-th percentile | 50.084075 |
| Maximum | 50.084075 |
| Range | 20.623179 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.115699411 |
|---|---|
| Coefficient of variation (CV) | 0.04256574371 |
| Kurtosis | 41.20322081 |
| Mean | 49.70427453 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -6.274167344 |
| Sum | 1928028.809 |
| Variance | 4.476183998 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) | |
| 50.084075 | 37270 | 74.5% | |
| 45.548841 | 621 | 1.2% | |
| 37.751 | 347 | 0.7% | |
| 39.463282 | 168 | 0.3% | |
| 31.997176 | 93 | 0.2% | |
| 39.493088 | 90 | 0.2% | |
| 31.567824 | 69 | 0.1% | |
| 36.628256 | 37 | 0.1% | |
| 31.870154 | 33 | 0.1% | |
| 33.41516 | 19 | < 0.1% | |
| Other values (13) | 43 | 0.1% | |
| (Missing) | 11210 | 22.4% |
| Value | Count | Frequency (%) | |
| 29.460896 | 2 | < 0.1% | |
| 31.143642 | 7 | < 0.1% | |
| 31.563901 | 2 | < 0.1% | |
| 31.567824 | 69 | 0.1% | |
| 31.870154 | 33 | 0.1% |
| Value | Count | Frequency (%) | |
| 50.084075 | 37270 | 74.5% | |
| 49.528333 | 1 | < 0.1% | |
| 48.7192 | 1 | < 0.1% | |
| 45.57208 | 4 | < 0.1% | |
| 45.548841 | 621 | 1.2% |
| Distinct | 43546 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 6448 |
| Missing (%) | 12.9% |
| Memory size | 390.6 KiB |
| 2020-08-07T15:07:07.731+02:00[Europe/Berlin] | 2 |
|---|---|
| 2020-08-08T23:35:21.110+02:00[Europe/Berlin] | 2 |
| 2020-08-08T15:26:43.244+02:00[Europe/Berlin] | 2 |
| 2020-08-08T17:08:22.287+02:00[Europe/Berlin] | 2 |
| 2020-08-02T13:33:03.821+02:00[Europe/Berlin] | 2 |
| Other values (43541) |
| Value | Count | Frequency (%) | |
| 2020-08-07T15:07:07.731+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-08T23:35:21.110+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-08T15:26:43.244+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-08T17:08:22.287+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-02T13:33:03.821+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-08T01:29:21.716+02:00[Europe/Berlin] | 2 | < 0.1% | |
| 2020-08-02T18:11:12.159+02:00[Europe/Berlin] | 1 | < 0.1% | |
| 2020-08-02T18:45:39.212+02:00[Europe/Berlin] | 1 | < 0.1% | |
| 2020-08-08T20:15:38.566+02:00[Europe/Rome] | 1 | < 0.1% | |
| 2020-08-07T02:47:07.177+02:00[Europe/Berlin] | 1 | < 0.1% | |
| Other values (43536) | 43536 | 87.1% | |
| (Missing) | 6448 | 12.9% |
Frequencies of value counts
Unique
| Unique | 43540 ? |
|---|---|
| Unique (%) | > 99.9% |
Histogram of lengths of the category
Length
| Max length | 50 |
|---|---|
| Median length | 44 |
| Mean length | 38.7329 |
| Min length | 3 |
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7253 |
| Missing (%) | 14.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -18.60561574 |
|---|---|
| Minimum | -157.886471 |
| Maximum | 150.7761 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | -157.886471 |
|---|---|
| 5-th percentile | -119.7143 |
| Q1 | -76.120398 |
| median | 8.25384 |
| Q3 | 8.25384 |
| 95-th percentile | 8.25384 |
| Maximum | 150.7761 |
| Range | 308.662571 |
| Interquartile range (IQR) | 84.374238 |
Descriptive statistics
| Standard deviation | 46.82575941 |
|---|---|
| Coefficient of variation (CV) | -2.516754085 |
| Kurtosis | -0.222193917 |
| Mean | -18.60561574 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.1977836 |
| Sum | -795334.2558 |
| Variance | 2192.651744 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 8.25384 | 30230 | 60.5% | |
| -97.822 | 3140 | 6.3% | |
| -82.142573 | 2739 | 5.5% | |
| -119.7143 | 2626 | 5.3% | |
| -6.2488 | 660 | 1.3% | |
| -78.375 | 526 | 1.1% | |
| 4.8975 | 463 | 0.9% | |
| -78.1539 | 251 | 0.5% | |
| -110.376817 | 231 | 0.5% | |
| -121.8914 | 200 | 0.4% | |
| Other values (118) | 1681 | 3.4% | |
| (Missing) | 7253 | 14.5% |
| Value | Count | Frequency (%) | |
| -157.886471 | 6 | < 0.1% | |
| -123.0386 | 1 | < 0.1% | |
| -122.4946 | 7 | < 0.1% | |
| -122.3451 | 7 | < 0.1% | |
| -122.3412 | 63 | 0.1% |
| Value | Count | Frequency (%) | |
| 150.7761 | 1 | < 0.1% | |
| 143.2104 | 9 | < 0.1% | |
| 139.69 | 7 | < 0.1% | |
| 127.112121 | 9 | < 0.1% | |
| 126.9783 | 1 | < 0.1% |
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11210 |
| Missing (%) | 22.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.080586965 |
|---|---|
| Minimum | -110.376817 |
| Maximum | 139.69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | -110.376817 |
|---|---|
| 5-th percentile | 8.25384 |
| Q1 | 8.25384 |
| median | 8.25384 |
| Q3 | 8.25384 |
| 95-th percentile | 8.25384 |
| Maximum | 139.69 |
| Range | 250.066817 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.71014307 |
|---|---|
| Coefficient of variation (CV) | 2.419197877 |
| Kurtosis | 40.8988417 |
| Mean | 6.080586965 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -6.421194996 |
| Sum | 235865.9684 |
| Variance | 216.3883093 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) | |
| 8.25384 | 37270 | 74.5% | |
| 11.537428 | 621 | 1.2% | |
| -97.822 | 347 | 0.7% | |
| -76.120398 | 168 | 0.3% | |
| -81.230724 | 93 | 0.2% | |
| -76.172541 | 90 | 0.2% | |
| -110.376817 | 69 | 0.1% | |
| -87.462866 | 37 | 0.1% | |
| -81.631076 | 33 | 0.1% | |
| -82.142573 | 19 | < 0.1% | |
| Other values (13) | 43 | 0.1% | |
| (Missing) | 11210 | 22.4% |
| Value | Count | Frequency (%) | |
| -110.376817 | 69 | 0.1% | |
| -110.349555 | 2 | < 0.1% | |
| -106.6583 | 2 | < 0.1% | |
| -98.43834 | 2 | < 0.1% | |
| -97.822 | 347 | 0.7% |
| Value | Count | Frequency (%) | |
| 139.69 | 2 | < 0.1% | |
| 11.537428 | 621 | 1.2% | |
| 11.52669 | 4 | < 0.1% | |
| 8.961 | 1 | < 0.1% | |
| 8.25384 | 37270 | 74.5% |
| Distinct | 4260 |
|---|---|
| Distinct (%) | 66.4% |
| Missing | 43581 |
| Missing (%) | 87.2% |
| Memory size | 390.6 KiB |
| child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=4/5 bytes/io=0.06K/0.05K | 311 |
|---|---|
| child statistics: [0] pending=0 bytes=0K/0K chunks=10/9 io=3/5 bytes/io=0.08K/0.05K | 225 |
| child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=5/5 bytes/io=0.05K/0.05K | 169 |
| child statistics: [3] pending=0 bytes=0K/0K chunks=9/10 io=3/6 bytes/io=0.08K/0.04K | 139 |
| child statistics: [1] pending=0 bytes=0K/0K chunks=9/10 io=4/6 bytes/io=0.06K/0.04K | 128 |
| Other values (4255) |
| Value | Count | Frequency (%) | |
| child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=4/5 bytes/io=0.06K/0.05K | 311 | 0.6% | |
| child statistics: [0] pending=0 bytes=0K/0K chunks=10/9 io=3/5 bytes/io=0.08K/0.05K | 225 | 0.4% | |
| child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=5/5 bytes/io=0.05K/0.05K | 169 | 0.3% | |
| child statistics: [3] pending=0 bytes=0K/0K chunks=9/10 io=3/6 bytes/io=0.08K/0.04K | 139 | 0.3% | |
| child statistics: [1] pending=0 bytes=0K/0K chunks=9/10 io=4/6 bytes/io=0.06K/0.04K | 128 | 0.3% | |
| child statistics: [2] pending=0 bytes=0K/0K chunks=9/10 io=3/6 bytes/io=0.08K/0.04K | 105 | 0.2% | |
| child statistics: [0] pending=0 bytes=0K/0K chunks=10/9 io=5/5 bytes/io=0.05K/0.05K | 104 | 0.2% | |
| child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=3/5 bytes/io=0.08K/0.05K | 86 | 0.2% | |
| child statistics: [3] pending=0 bytes=0K/0K chunks=9/10 io=4/6 bytes/io=0.06K/0.04K | 84 | 0.2% | |
| child statistics: [2] pending=0 bytes=0K/0K chunks=9/10 io=4/6 bytes/io=0.06K/0.04K | 80 | 0.2% | |
| Other values (4250) | 4988 | 10.0% | |
| (Missing) | 43581 | 87.2% |
Frequencies of value counts
Unique
| Unique | 4229 ? |
|---|---|
| Unique (%) | 65.9% |
Histogram of lengths of the category
Length
| Max length | 175 |
|---|---|
| Median length | 3 |
| Mean length | 17.11254 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43581 |
| Missing (%) | 87.2% |
| Memory size | 390.6 KiB |
| parent | |
|---|---|
| child | 45 |
| Value | Count | Frequency (%) | |
| parent | 6374 | 12.7% | |
| child | 45 | 0.1% | |
| (Missing) | 43581 | 87.2% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.38424 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 49995 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2755913.8 |
|---|---|
| Minimum | 1584139 |
| Maximum | 5142184 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 1584139 |
|---|---|
| 5-th percentile | 1666657.6 |
| Q1 | 1996732 |
| median | 2225841 |
| Q3 | 2830673 |
| 95-th percentile | 4679881.8 |
| Maximum | 5142184 |
| Range | 3558045 |
| Interquartile range (IQR) | 833941 |
Descriptive statistics
| Standard deviation | 1408036.289 |
|---|---|
| Coefficient of variation (CV) | 0.5109144884 |
| Kurtosis | 3.042084392 |
| Mean | 2755913.8 |
| Median Absolute Deviation (MAD) | 604832 |
| Skewness | 1.700550509 |
| Sum | 13779569 |
| Variance | 1.982566192e+12 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 5142184 | 1 | < 0.1% | |
| 2830673 | 1 | < 0.1% | |
| 2225841 | 1 | < 0.1% | |
| 1996732 | 1 | < 0.1% | |
| 1584139 | 1 | < 0.1% | |
| (Missing) | 49995 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1584139 | 1 | < 0.1% | |
| 1996732 | 1 | < 0.1% | |
| 2225841 | 1 | < 0.1% | |
| 2830673 | 1 | < 0.1% | |
| 5142184 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5142184 | 1 | < 0.1% | |
| 2830673 | 1 | < 0.1% | |
| 2225841 | 1 | < 0.1% | |
| 1996732 | 1 | < 0.1% | |
| 1584139 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 40.0% |
| Missing | 49995 |
| Missing (%) | > 99.9% |
| Memory size | 390.6 KiB |
| 0 | 4 |
|---|---|
| 1 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 4 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| (Missing) | 49995 | > 99.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 40.0% |
| Missing | 49995 |
| Missing (%) | > 99.9% |
| Memory size | 390.6 KiB |
| 0 | 4 |
|---|---|
| 1.9e-05 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 4 | < 0.1% | |
| 1.9e-05 | 1 | < 0.1% | |
| (Missing) | 49995 | > 99.9% |
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16526 |
| Missing (%) | 33.1% |
| Memory size | 390.6 KiB |
| HQ, 5TH SIGNAL COMMAND | |
|---|---|
| HQ, 7TH SIGNAL COMMAND | 2817 |
| US ARMY NETWORK ENTERPRISE TECHNOLOGY COMMAND | 145 |
| PEO-C3T | 58 |
| USA SIGNAL NETWORK ENTERPRISE CNTR-FORT BELVOIR | 19 |
| Other values (31) | 205 |
| Value | Count | Frequency (%) | |
| HQ, 5TH SIGNAL COMMAND | 30230 | 60.5% | |
| HQ, 7TH SIGNAL COMMAND | 2817 | 5.6% | |
| US ARMY NETWORK ENTERPRISE TECHNOLOGY COMMAND | 145 | 0.3% | |
| PEO-C3T | 58 | 0.1% | |
| USA SIGNAL NETWORK ENTERPRISE CNTR-FORT BELVOIR | 19 | < 0.1% | |
| NEC FORT MEADE | 17 | < 0.1% | |
| RNEC-APG | 16 | < 0.1% | |
| FORT SAM HOUSTON | 16 | < 0.1% | |
| PROGRAM EXECUTIVE OFFICE FOR COMMAND, CONTROL | 16 | < 0.1% | |
| US ARMY CRIMINAL INVESTIGATION COMMAND | 14 | < 0.1% | |
| Other values (26) | 126 | 0.3% | |
| (Missing) | 16526 | 33.1% |
Frequencies of value counts
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 47 |
|---|---|
| Median length | 22 |
| Mean length | 15.7886 |
| Min length | 3 |
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11565 |
| Missing (%) | 23.1% |
| Memory size | 390.6 KiB |
| HQ, 5TH SIGNAL COMMAND | |
|---|---|
| 173RD AIRBORNE BRIGADE | 621 |
| PEO-C3T | 168 |
| 3RD COMBAT AVIATION BDE, 3RD INF DIV | 93 |
| PROGRAM EXECUTIVE OFFICE FOR COMMAND, CONTROL | 90 |
| Other values (13) | 193 |
| Value | Count | Frequency (%) | |
| HQ, 5TH SIGNAL COMMAND | 37270 | 74.5% | |
| 173RD AIRBORNE BRIGADE | 621 | 1.2% | |
| PEO-C3T | 168 | 0.3% | |
| 3RD COMBAT AVIATION BDE, 3RD INF DIV | 93 | 0.2% | |
| PROGRAM EXECUTIVE OFFICE FOR COMMAND, CONTROL | 90 | 0.2% | |
| HQ, 7TH SIGNAL COMMAND | 87 | 0.2% | |
| 101ST COMBAT AVIATION BRIGADE | 37 | 0.1% | |
| 2ND BRIGADE COMBAT TEAM, 3RD INFANTRY DIVISION | 33 | 0.1% | |
| US ARMY INSPECTOR GENERAL AGENCY | 10 | < 0.1% | |
| 1ST CAVALRY DIVISION | 7 | < 0.1% | |
| Other values (8) | 19 | < 0.1% | |
| (Missing) | 11565 | 23.1% |
Frequencies of value counts
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 46 |
|---|---|
| Median length | 22 |
| Mean length | 17.64272 |
| Min length | 3 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 43576 |
| Missing (%) | 87.2% |
| Memory size | 390.6 KiB |
| manager | |
|---|---|
| proxy-1 | |
| worker-1-1 | |
| worker-1-2 | |
| worker-1-3 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| manager | 1624 | 3.2% | |
| proxy-1 | 1602 | 3.2% | |
| worker-1-1 | 775 | 1.6% | |
| worker-1-2 | 749 | 1.5% | |
| worker-1-3 | 722 | 1.4% | |
| worker-1-4 | 702 | 1.4% | |
| worker-1-5 | 134 | 0.3% | |
| worker-1-6 | 116 | 0.2% | |
| (Missing) | 43576 | 87.2% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 10 |
|---|---|
| Median length | 3 |
| Mean length | 3.7058 |
| Min length | 3 |
| Distinct | 2561 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5428.622636 |
|---|---|
| Minimum | 0 |
| Maximum | 65534 |
| Zeros | 334 |
| Zeros (%) | 0.7% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 53 |
| Q1 | 53 |
| median | 389 |
| Q3 | 500 |
| 95-th percentile | 50514.5 |
| Maximum | 65534 |
| Range | 65534 |
| Interquartile range (IQR) | 447 |
Descriptive statistics
| Standard deviation | 13664.79448 |
|---|---|
| Coefficient of variation (CV) | 2.517175239 |
| Kurtosis | 9.355058085 |
| Mean | 5428.622636 |
| Median Absolute Deviation (MAD) | 336 |
| Skewness | 3.187526624 |
| Sum | 236557660 |
| Variance | 186726608.2 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 53 | 11712 | 23.4% | |
| 443 | 8671 | 17.3% | |
| 123 | 3665 | 7.3% | |
| 389 | 2962 | 5.9% | |
| 17472 | 2753 | 5.5% | |
| 445 | 1174 | 2.3% | |
| 80 | 1173 | 2.3% | |
| 137 | 984 | 2.0% | |
| 9100 | 744 | 1.5% | |
| 8443 | 559 | 1.1% | |
| Other values (2551) | 9179 | 18.4% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 334 | 0.7% | |
| 1 | 13 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 130 | 0.3% | |
| 4 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 65534 | 8 | < 0.1% | |
| 65524 | 1 | < 0.1% | |
| 65514 | 1 | < 0.1% | |
| 65498 | 1 | < 0.1% | |
| 65489 | 1 | < 0.1% |
| Distinct | 17331 |
|---|---|
| Distinct (%) | 39.8% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45179.4502 |
|---|---|
| Minimum | 0 |
| Maximum | 65535 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Memory size | 390.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 123 |
| Q1 | 44304 |
| median | 53365 |
| Q3 | 59274 |
| 95-th percentile | 64268 |
| Maximum | 65535 |
| Range | 65535 |
| Interquartile range (IQR) | 14970 |
Descriptive statistics
| Standard deviation | 21575.02823 |
|---|---|
| Coefficient of variation (CV) | 0.4775407432 |
| Kurtosis | 0.1696762493 |
| Mean | 45179.4502 |
| Median Absolute Deviation (MAD) | 6177.5 |
| Skewness | -1.330050899 |
| Sum | 1968739722 |
| Variance | 465481843.1 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 123 | 3626 | 7.3% | |
| 5985 | 1797 | 3.6% | |
| 137 | 983 | 2.0% | |
| 8 | 329 | 0.7% | |
| 443 | 281 | 0.6% | |
| 3 | 151 | 0.3% | |
| 39535 | 112 | 0.2% | |
| 36402 | 63 | 0.1% | |
| 500 | 60 | 0.1% | |
| 52954 | 58 | 0.1% | |
| Other values (17321) | 36116 | 72.2% | |
| (Missing) | 6424 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 6 | < 0.1% | |
| 3 | 151 | 0.3% | |
| 8 | 329 | 0.7% | |
| 11 | 6 | < 0.1% | |
| 13 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 65535 | 1 | < 0.1% | |
| 65532 | 4 | < 0.1% | |
| 65530 | 4 | < 0.1% | |
| 65529 | 2 | < 0.1% | |
| 65528 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| False | |
|---|---|
| True | 597 |
| (Missing) |
| Value | Count | Frequency (%) | |
| False | 42979 | 86.0% | |
| True | 597 | 1.2% | |
| (Missing) | 6424 | 12.8% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43581 |
| Missing (%) | 87.2% |
| Memory size | 390.6 KiB |
| info |
|---|
| Value | Count | Frequency (%) | |
| info | 6419 | 12.8% | |
| (Missing) | 43581 | 87.2% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.12838 |
| Min length | 3 |
SITE_COLLECTION
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| usareur-tlaw-nj | |
|---|---|
| usareur-apck-nj | |
| usareur-tlas-nj | |
| usareur-apcg-nj | |
| usareur-coi8-nl | |
| Other values (7) |
| Value | Count | Frequency (%) | |
| usareur-tlaw-nj | 14330 | 28.7% | |
| usareur-apck-nj | 12823 | 25.6% | |
| usareur-tlas-nj | 9194 | 18.4% | |
| usareur-apcg-nj | 5695 | 11.4% | |
| usareur-coi8-nl | 2037 | 4.1% | |
| usareur-tlal-nla | 1173 | 2.3% | |
| usareur-tlal-nlp | 1106 | 2.2% | |
| usareur-coi4-nl | 946 | 1.9% | |
| rss-gcc-t1 | 927 | 1.9% | |
| usareur-coi3-nl | 618 | 1.2% | |
| Other values (2) | 1151 | 2.3% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 14.95288 |
| Min length | 10 |
| Distinct | 49932 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| 2020-08-07T14:13:50.764Z | 2 |
|---|---|
| 2020-08-02T17:55:26.122Z | 2 |
| 2020-08-07T13:17:15.04Z | 2 |
| 2020-08-07T09:38:33.319Z | 2 |
| 2020-08-08T02:42:57.495Z | 2 |
| Other values (49927) |
| Value | Count | Frequency (%) | |
| 2020-08-07T14:13:50.764Z | 2 | < 0.1% | |
| 2020-08-02T17:55:26.122Z | 2 | < 0.1% | |
| 2020-08-07T13:17:15.04Z | 2 | < 0.1% | |
| 2020-08-07T09:38:33.319Z | 2 | < 0.1% | |
| 2020-08-08T02:42:57.495Z | 2 | < 0.1% | |
| 2020-08-07T17:38:33.648Z | 2 | < 0.1% | |
| 2020-08-08T13:26:43.244Z | 2 | < 0.1% | |
| 2020-08-07T00:37:53.897Z | 2 | < 0.1% | |
| 2020-08-07T04:32:33.285Z | 2 | < 0.1% | |
| 2020-08-08T20:34:29.893Z | 2 | < 0.1% | |
| Other values (49922) | 49980 | > 99.9% |
Frequencies of value counts
Unique
| Unique | 49864 ? |
|---|---|
| Unique (%) | 99.7% |
Histogram of lengths of the category
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 23.88942 |
| Min length | 20 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| tcp | |
|---|---|
| udp | |
| icmp | 496 |
| Value | Count | Frequency (%) | |
| tcp | 24977 | 50.0% | |
| udp | 18103 | 36.2% | |
| icmp | 496 | 1.0% | |
| (Missing) | 6424 | 12.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.00992 |
| Min length | 3 |
| Distinct | 150 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 49171 |
| Missing (%) | 98.3% |
| Memory size | 390.6 KiB |
| CxfW4t4Rt0M3AfFRe1 | 24 |
|---|---|
| CSblFE4uQ1IVgXSorc | 24 |
| CuOoXF29ROmzzkyu5k | 22 |
| CpJs8z3kIw0L1ZWay5 | 22 |
| CM0ydC1RMqcgjgDwAh | 22 |
| Other values (145) |
| Value | Count | Frequency (%) | |
| CxfW4t4Rt0M3AfFRe1 | 24 | < 0.1% | |
| CSblFE4uQ1IVgXSorc | 24 | < 0.1% | |
| CuOoXF29ROmzzkyu5k | 22 | < 0.1% | |
| CpJs8z3kIw0L1ZWay5 | 22 | < 0.1% | |
| CM0ydC1RMqcgjgDwAh | 22 | < 0.1% | |
| ClNMRV1NYjm8fBaGbi | 21 | < 0.1% | |
| C3Jcrk1LaFlHsoTmBc | 20 | < 0.1% | |
| CouFAj29LEcppMqjk4 | 19 | < 0.1% | |
| C5Y8UyfKfI1rUDEF2 | 18 | < 0.1% | |
| CefH9w4HvFwRM4Hkz6 | 17 | < 0.1% | |
| Other values (140) | 620 | 1.2% | |
| (Missing) | 49171 | 98.3% |
Frequencies of value counts
Unique
| Unique | 59 ? |
|---|---|
| Unique (%) | 7.1% |
Histogram of lengths of the category
Length
| Max length | 37 |
|---|---|
| Median length | 3 |
| Mean length | 3.2466 |
| Min length | 3 |
TYPE_BRO
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 390.6 KiB |
| conn | |
|---|---|
| communication | |
| capture_loss | 5 |
| Value | Count | Frequency (%) | |
| conn | 43576 | 87.2% | |
| communication | 6419 | 12.8% | |
| capture_loss | 5 | < 0.1% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 13 |
|---|---|
| Median length | 4 |
| Mean length | 5.15622 |
| Min length | 4 |
| Distinct | 43576 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6424 |
| Missing (%) | 12.8% |
| Memory size | 390.6 KiB |
| C0Gs5pB9UbVMnVKrj | 1 |
|---|---|
| C03arjKxL6GrFCZpl | 1 |
| C0J2ZT3wD1Mx5KAIci | 1 |
| C07f562RP8pPfPhwo1 | 1 |
| C04uNF2L35PgXeEVci | 1 |
| Other values (43571) |
| Value | Count | Frequency (%) | |
| C0Gs5pB9UbVMnVKrj | 1 | < 0.1% | |
| C03arjKxL6GrFCZpl | 1 | < 0.1% | |
| C0J2ZT3wD1Mx5KAIci | 1 | < 0.1% | |
| C07f562RP8pPfPhwo1 | 1 | < 0.1% | |
| C04uNF2L35PgXeEVci | 1 | < 0.1% | |
| C0MZIX1e5CdSes6FP | 1 | < 0.1% | |
| C00inL2qt4m0RjPs93 | 1 | < 0.1% | |
| C086svQU58bCTK2Oe | 1 | < 0.1% | |
| C0DqAO1Uv7eD4Hqgi6 | 1 | < 0.1% | |
| C0UTMo3Q2znmQFaSNj | 1 | < 0.1% | |
| Other values (43566) | 43566 | 87.1% | |
| (Missing) | 6424 | 12.8% |
Frequencies of value counts
Unique
| Unique | 43576 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 15.84224 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Id | Timestamp | Data Type | Visibility | APPLICATIONPROTOCOL | ASN_DST | ASN_SRC | COCOM_DST | COCOM_SRC | CONNECTIONDETAIL | CONNECTIONORIGIN_SRC | CONNECTIONSTATE_BRO | COUNTRY_DST | COUNTRY_SRC | COUNT_BYTES_IN | COUNT_BYTES_IN_ONTHEWIRE | COUNT_BYTES_MISSING | COUNT_BYTES_OUT | COUNT_BYTES_OUT_ONTHEWIRE | COUNT_PACKETS_DST | COUNT_PACKETS_SRC | DURATION | DURATION_LOG | FILENAME_INGEST | IPBRANCHCATEGORY_DST | IPBRANCHCATEGORY_SRC | IP_DST | IP_SRC | LATITUDE_DST | LATITUDE_SRC | LOCAL_TIMESTAMP | LONGITUDE_DST | LONGITUDE_SRC | MESSAGE | MSGSOURCE_BRO | NUMPACKETS_ACK | NUMPACKETS_LOSS | NUMPACKETS_LOSS_PERCENT | ORGANIZATION_OWNER_DST | ORGANIZATION_OWNER_SRC | PEERNAME | PORT_DST | PORT_SRC | RESPONSEORIGIN_DST | SEVERITY_MESSAGE | SITE_COLLECTION | TIME_RECEIPT | TRANSPORTPROTOCOL | TUNNELPARENTUUIDS | TYPE_BRO | UUID_BRO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 002eb37302a3731459ff6127495630fb | 1596892957292 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-1330.bro-communication.c5072.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [1] pending=0 bytes=0K/0K chunks=10/9 io=4/5 bytes/io=0.06K/0.05K | parent | NaN | NaN | NaN | NaN | NaN | worker-1-1 | NaN | NaN | NaN | info | usareur-tlaw-nj | 2020-08-08T13:22:37.292Z | NaN | NaN | communication | NaN |
| 1 | 004d6e692bcf67cde35fa94b1718d497 | 1596885597739 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi5-nl__usareur-coi5-nl.2020-08-08-1130.bro-communication.0a05d.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [0] pending=0 bytes=2K/0K chunks=14/9 io=4/5 bytes/io=0.56K/0.05K | parent | NaN | NaN | NaN | NaN | NaN | worker-1-3 | NaN | NaN | NaN | info | usareur-coi5-nl | 2020-08-08T11:19:57.739Z | NaN | NaN | communication | NaN |
| 2 | 0062ca060d4cef18f85774a3e46aa60c | 1596876837734 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi5-nl__usareur-coi5-nl.2020-08-08-0900.bro-communication.06210.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [1] pending=0 bytes=706509K/15522273K chunks=7017226/16016519 io=3202948/8008260 bytes/io=0.22K/1.94K | parent | NaN | NaN | NaN | NaN | NaN | worker-1-1 | NaN | NaN | NaN | info | usareur-coi5-nl | 2020-08-08T08:53:57.734Z | NaN | NaN | communication | NaN |
| 3 | 007deaa53585387aa070ec5a2033e4b9 | 1596917850132 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi2-nl__usareur-coi2-nl.2020-08-08-2030.bro-communication.9aa4e.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | parent statistics: pending=0 bytes=14629K/1219913K chunks=170876/1334984 io=78334/1266963 bytes/io=0.19K/0.96K events=67693/60614 operations=0/0 | parent | NaN | NaN | NaN | NaN | NaN | worker-1-4 | NaN | NaN | NaN | info | usareur-coi2-nl | 2020-08-08T20:17:30.132Z | NaN | NaN | communication | NaN |
| 4 | 008b98dafd5d34d7a40c76501332fd5f | 1596928982203 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-tlal-nlp__usareur-tlal-nlp.2020-08-08-2330.bro-communication.ac5b0.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [4] pending=0 bytes=27173966K/3558569K chunks=41080461/31365846 io=20527048/15682924 bytes/io=1.32K/0.23K | parent | NaN | NaN | NaN | NaN | NaN | manager | NaN | NaN | NaN | info | usareur-tlal-nlp | 2020-08-08T23:23:02.203Z | NaN | NaN | communication | NaN |
| 5 | 00bf5331ad4f6d6ed85bee75a6c70b69 | 1596903834870 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-tlal-nlp__usareur-tlal-nlp.2020-08-08-1630.bro-communication.57378.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | parent statistics: pending=0 bytes=3556569K/27114798K chunks=31393574/40852114 io=15654463/25255412 bytes/io=0.23K/1.07K events=15602470/15566275 operations=0/0 | parent | NaN | NaN | NaN | NaN | NaN | worker-1-6 | NaN | NaN | NaN | info | usareur-tlal-nlp | 2020-08-08T16:23:54.87Z | NaN | NaN | communication | NaN |
| 6 | 00c117654e7053788049b433860be33c | 1596845288084 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-0015.bro-communication.787a3.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [0] pending=0 bytes=0K/0K chunks=10/9 io=3/5 bytes/io=0.08K/0.05K | parent | NaN | NaN | NaN | NaN | NaN | worker-1-1 | NaN | NaN | NaN | info | usareur-apck-nj | 2020-08-08T00:08:08.084Z | NaN | NaN | communication | NaN |
| 7 | 00d7db3dd0a84f4f7564289dc03bbe4b | 1596900201608 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi3-nl__usareur-coi3-nl.2020-08-08-1530.bro-communication.973a9.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [0] pending=0 bytes=6886K/364541K chunks=68794/341373 io=33170/170687 bytes/io=0.21K/2.14K | parent | NaN | NaN | NaN | NaN | NaN | worker-1-4 | NaN | NaN | NaN | info | usareur-coi3-nl | 2020-08-08T15:23:21.608Z | NaN | NaN | communication | NaN |
| 8 | 00e70f830684623afb22abf7ca76fd8e | 1596874699705 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi3-nl__usareur-coi3-nl.2020-08-08-0830.bro-communication.86063.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | child statistics: [1] pending=0 bytes=0K/0K chunks=9/10 io=3/6 bytes/io=0.08K/0.04K | parent | NaN | NaN | NaN | NaN | NaN | proxy-1 | NaN | NaN | NaN | info | usareur-coi3-nl | 2020-08-08T08:18:19.705Z | NaN | NaN | communication | NaN |
| 9 | 00fc05e3e6be90ddde9a61a189243f38 | 1596852200088 | bro-e-communication | U&FOUO | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | bro-e__usareur-coi4-nl__usareur-coi4-nl.2020-08-08-0215.bro-communication.dc0a6.gz | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | parent statistics: pending=0 bytes=1592342K/49451898K chunks=15430440/26093162 io=7410006/18096906 bytes/io=0.21K/2.73K events=7621860/7773834 operations=0/0 | parent | NaN | NaN | NaN | NaN | NaN | worker-1-4 | NaN | NaN | NaN | info | usareur-coi4-nl | 2020-08-08T02:03:20.088Z | NaN | NaN | communication | NaN |
Last rows
| Id | Timestamp | Data Type | Visibility | APPLICATIONPROTOCOL | ASN_DST | ASN_SRC | COCOM_DST | COCOM_SRC | CONNECTIONDETAIL | CONNECTIONORIGIN_SRC | CONNECTIONSTATE_BRO | COUNTRY_DST | COUNTRY_SRC | COUNT_BYTES_IN | COUNT_BYTES_IN_ONTHEWIRE | COUNT_BYTES_MISSING | COUNT_BYTES_OUT | COUNT_BYTES_OUT_ONTHEWIRE | COUNT_PACKETS_DST | COUNT_PACKETS_SRC | DURATION | DURATION_LOG | FILENAME_INGEST | IPBRANCHCATEGORY_DST | IPBRANCHCATEGORY_SRC | IP_DST | IP_SRC | LATITUDE_DST | LATITUDE_SRC | LOCAL_TIMESTAMP | LONGITUDE_DST | LONGITUDE_SRC | MESSAGE | MSGSOURCE_BRO | NUMPACKETS_ACK | NUMPACKETS_LOSS | NUMPACKETS_LOSS_PERCENT | ORGANIZATION_OWNER_DST | ORGANIZATION_OWNER_SRC | PEERNAME | PORT_DST | PORT_SRC | RESPONSEORIGIN_DST | SEVERITY_MESSAGE | SITE_COLLECTION | TIME_RECEIPT | TRANSPORTPROTOCOL | TUNNELPARENTUUIDS | TYPE_BRO | UUID_BRO | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49990 | C0Xzlx28sycxNjjdze | 1596899566066 | bro-e-conn | U&FOUO | NaN | 721.0 | 1556.0 | USNORTHCOM | USEUCOM | Dd | False | SF | US | DE | 57.0 | 85.0 | 0.0 | 57.0 | 85.0 | 1.0 | 1.0 | 0.100119 | NaN | bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-08-1515.bro-conn.8abe1.gz | Non-Army | Army | 214.71.0.1 | 155.24.116.43 | 37.751000 | 50.084075 | 2020-08-08T17:12:46.066+02:00[Europe/Berlin] | -97.82200 | 8.25384 | NaN | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | NaN | 53.0 | 35432.0 | False | NaN | usareur-tlas-nj | 2020-08-08T15:12:46.066Z | udp | NaN | conn | C0Xzlx28sycxNjjdze |
| 49991 | C0XzqC3vHsVM3vl3Q2 | 1596898835117 | bro-e-conn | U&FOUO | NaN | 386.0 | 1585.0 | USNORTHCOM | USEUCOM | Sr | False | REJ | US | DE | 0.0 | 40.0 | 0.0 | 0.0 | 48.0 | 1.0 | 1.0 | 0.000772 | NaN | bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-1515.bro-conn.ea828.gz | Non-Army | Army | 132.25.191.222 | 155.155.120.6 | 37.751000 | 50.084075 | 2020-08-08T17:00:35.117+02:00[Europe/Berlin] | -97.82200 | 8.25384 | NaN | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | NaN | 8200.0 | 60699.0 | False | NaN | usareur-tlaw-nj | 2020-08-08T15:00:35.117Z | tcp | NaN | conn | C0XzqC3vHsVM3vl3Q2 |
| 49992 | C0XzyHxr4nrkI2Xl | 1596907562374 | bro-e-conn | U&FOUO | NaN | 531.0 | 531.0 | USEUCOM | USEUCOM | ShADadtFf | False | SF | DE | DE | 8485.0 | 8977.0 | 0.0 | 5489.0 | 6061.0 | 12.0 | 14.0 | 60.352648 | NaN | bro-e__usareur-tlaw-nj__usareur-tlaw-nj.2020-08-08-1730.bro-conn.e1e18.gz | Army | Army | 136.215.66.206 | 136.207.68.114 | 50.084075 | 50.084075 | 2020-08-08T19:26:02.374+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 80.0 | 53237.0 | False | NaN | usareur-tlaw-nj | 2020-08-08T17:26:02.374Z | tcp | NaN | conn | C0XzyHxr4nrkI2Xl |
| 49993 | C0XzzjKDc2RQIetKh | 1596888089238 | bro-e-conn | U&FOUO | NaN | 30742.0 | 1566.0 | USEUCOM | USEUCOM | ShADadtFf | False | SF | DE | DE | 520471.0 | 537563.0 | 0.0 | 10970.0 | 27342.0 | 427.0 | 409.0 | 99.099975 | NaN | bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-08-1215.bro-conn.6b54d.gz | Non-Army | Army | 185.48.220.16 | 136.221.16.230 | 51.299300 | 50.084075 | 2020-08-08T14:01:29.238+02:00[Europe/Berlin] | 9.49100 | 8.25384 | NaN | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | NaN | 443.0 | 61994.0 | False | NaN | usareur-tlas-nj | 2020-08-08T12:01:29.238Z | tcp | NaN | conn | C0XzzjKDc2RQIetKh |
| 49994 | C0Y05g2A6r9bL0siB1 | 1596867312823 | bro-e-conn | U&FOUO | NaN | 16509.0 | 1566.0 | USNORTHCOM | USEUCOM | ShADadFf | False | SF | US | DE | 1553.0 | 1925.0 | 0.0 | 674.0 | 1046.0 | 9.0 | 9.0 | 0.112663 | NaN | bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-08-0630.bro-conn.702ce.gz | Non-Army | Army | 52.11.247.82 | 136.221.6.202 | 45.849100 | 50.084075 | 2020-08-08T08:15:12.823+02:00[Europe/Berlin] | -119.71430 | 8.25384 | NaN | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | NaN | 443.0 | 64236.0 | False | NaN | usareur-tlas-nj | 2020-08-08T06:15:12.823Z | tcp | NaN | conn | C0Y05g2A6r9bL0siB1 |
| 49995 | C0Y0G33GMBuXoJqKsl | 1596880920517 | bro-e-conn | U&FOUO | NaN | 531.0 | 1556.0 | USEUCOM | USEUCOM | Dd | False | SF | DE | DE | 109.0 | 137.0 | 0.0 | 56.0 | 84.0 | 1.0 | 1.0 | 0.007145 | NaN | bro-e__usareur-tlas-nj__usareur-tlas-nj.2020-08-08-1015.bro-conn.7c1d1.gz | Army | Army | 139.139.3.147 | 155.24.116.43 | 50.084075 | 50.084075 | 2020-08-08T12:02:00.517+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 53.0 | 40796.0 | False | NaN | usareur-tlas-nj | 2020-08-08T10:02:00.517Z | udp | NaN | conn | C0Y0G33GMBuXoJqKsl |
| 49996 | C0Y0WKc7AwBAOvMUh | 1596874447321 | bro-e-conn | U&FOUO | NaN | 1585.0 | 1580.0 | USEUCOM | USEUCOM | Dd | False | SF | DE | DE | 277.0 | 305.0 | 0.0 | 41.0 | 69.0 | 1.0 | 1.0 | 0.001077 | NaN | bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-0815.bro-conn.60f1d.gz | Army | Army | 155.155.72.10 | 147.35.183.45 | 50.084075 | 50.084075 | 2020-08-08T10:14:07.321+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 53.0 | 59920.0 | False | NaN | usareur-apck-nj | 2020-08-08T08:14:07.321Z | udp | NaN | conn | C0Y0WKc7AwBAOvMUh |
| 49997 | C0Y0YO2wQMEeAJKlYb | 1596898988575 | bro-e-conn | U&FOUO | NaN | 1585.0 | 1580.0 | USEUCOM | USEUCOM | Dd | False | SF | DE | DE | 64.0 | 92.0 | 0.0 | 48.0 | 76.0 | 1.0 | 1.0 | 0.001221 | NaN | bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-1515.bro-conn.97cb0.gz | Army | Army | 155.155.72.10 | 147.35.52.168 | 50.084075 | 50.084075 | 2020-08-08T17:03:08.575+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 53.0 | 54446.0 | False | NaN | usareur-apck-nj | 2020-08-08T15:03:08.575Z | udp | NaN | conn | C0Y0YO2wQMEeAJKlYb |
| 49998 | C0Y0dS1VaHRcOlCMS3 | 1596873326762 | bro-e-conn | U&FOUO | NaN | 531.0 | 1580.0 | USEUCOM | USEUCOM | Da | False | OTH | DE | DE | 0.0 | 40.0 | 0.0 | 210.0 | 250.0 | 1.0 | 1.0 | 0.061414 | NaN | bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-0815.bro-conn.60f1d.gz | Army | Army | 136.215.66.201 | 147.35.113.138 | 50.084075 | 50.084075 | 2020-08-08T09:55:26.762+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 10123.0 | 60116.0 | False | NaN | usareur-apck-nj | 2020-08-08T07:55:26.762Z | tcp | NaN | conn | C0Y0dS1VaHRcOlCMS3 |
| 49999 | C0Y0hw4QKpYI1ysZa3 | 1596863009021 | bro-e-conn | U&FOUO | NaN | 1559.0 | 1585.0 | USEUCOM | USEUCOM | NaN | False | OTH | DE | DE | 0.0 | 0.0 | 0.0 | 112.0 | 168.0 | 0.0 | 2.0 | 3.001537 | NaN | bro-e__usareur-apck-nj__usareur-apck-nj.2020-08-08-0515.bro-conn.68031.gz | Army | Army | 147.36.249.39 | 155.155.234.28 | 50.084075 | 50.084075 | 2020-08-08T07:03:29.021+02:00[Europe/Berlin] | 8.25384 | 8.25384 | NaN | NaN | NaN | NaN | NaN | HQ, 5TH SIGNAL COMMAND | HQ, 5TH SIGNAL COMMAND | NaN | 0.0 | 8.0 | False | NaN | usareur-apck-nj | 2020-08-08T05:03:29.021Z | icmp | NaN | conn | C0Y0hw4QKpYI1ysZa3 |